/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 * 
 *      http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package net.phoenix.repository.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Date;

import net.phoenix.repository.SQLParameter;

/**
 * Jigsaw server
 * 
 * @author    <a href="shamphone@gmail.com">Li XiongFeng</a>
 * @date      2012-11-24
 * @version   1.0.0
 */
public abstract class ValueTableSearchDao extends JdbcDao {
	public abstract ResultSet search(String query, SQLParameter[] parameters, long fromIndex, long number) throws SQLException;
	
	public abstract int count(String query, SQLParameter[] parameters, long fromIndex, long number) throws SQLException;

	protected PreparedStatement createStatement(String sql, SQLParameter[] parameters) throws SQLException {
		PreparedStatement command = null;
		command = connection.prepareStatement(sql);
		if ((parameters != null) && (parameters.length > 0)) {
			for (int i = 0; i < parameters.length; i++) {
				Object value = parameters[i].getValue();
				if (value instanceof Date) {
					value = toTimestame((Date) value);
					command.setTimestamp(i + 1, (Timestamp) value);
				} else {
					command.setObject(i + 1, value);
				}
			}
		}
		return command;
	}

}
